Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Excel 2007
This is driving me nuts, primarily because I know that I've done this before, but I just can't seem to zero in on the solution today, and I haven't been able to find it in my other files. I need a formula that does the following two things: 1) If the current day is a Friday, put the current date 2) In all other cases put the date of the *next* Friday I seem to remember that this requires a combination of the DATE(), DAY(), NOW(), and WEEKDAY() functions. I also seem to remember that the solution *may* include use of the MOD() function. Anyone have a way to do this? --Tom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If weekend date display previous Friday date | Excel Discussion (Misc queries) | |||
Need to find each day prior to first friday, monthly | Excel Worksheet Functions | |||
the date always friday | New Users to Excel | |||
Find out first Friday every month | Excel Discussion (Misc queries) | |||
Find out first Friday every month | Excel Worksheet Functions |