On calendars the "saints" and the "notes"
Retraite88
-
Retraite88 -
Retraite88 -
Hello to EVERYONE and my best wishes for 2018
With Excel 2016
I have a sheet named jours-saints with 3 columns named in
- in A date of A2:A367
- in B title of B2:B367
- in C notes of C2:C367
On my first sheet January. (1 month per sheet)
2018 January (C2) Today we are: Friday January 19, 2018 (F2)
The date is auto with the formula =TODAY()
In my cell C2, behind the month, I would like to see the “saint of the day” from the sheet jours-saints appear, and after the date in cell F2 the notes from the sheet jours-saints.
Regards
RP
Configuration: Windows / Firefox 57.0
With Excel 2016
I have a sheet named jours-saints with 3 columns named in
- in A date of A2:A367
- in B title of B2:B367
- in C notes of C2:C367
On my first sheet January. (1 month per sheet)
2018 January (C2) Today we are: Friday January 19, 2018 (F2)
The date is auto with the formula =TODAY()
In my cell C2, behind the month, I would like to see the “saint of the day” from the sheet jours-saints appear, and after the date in cell F2 the notes from the sheet jours-saints.
Regards
RP
Configuration: Windows / Firefox 57.0
2 answers
-
Hello
Attach the workbook without confidential data as a file on
https://mon-partage.fr/
and right-click to copy the shortcut and paste into your message
Awaiting
Michel -
Good evening
Best wishes to you as well
Select the range A2:C367 and in the Name Manager area give it the name base
Then in C2 the formula =VLOOKUP(TODAY(),base,2,FALSE)
In G2 the formula =VLOOKUP(TODAY(),base,3,FALSE)
Cdlmnt
Via
--
"Imagination is more important than knowledge." A. Einstein
