Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
On a bi-weekly time sheet, I need 2 cells populated with the "week-ending"
dates of the 2 past weeks. These dates are always the 2 previous Fridays, but the spreadsheet may be accessed before, on or after the 2nd Friday (within a couple days). For example, today we're submitting time sheets for the weeks ending 12/22 and 12/29. Some folks may have filled theirs out yesterday, and some stragglers will fill them out on Monday. I would like the spreadsheet to pre-fill with those 2 week-ending dates, in 2 separate cells. Possible? Thanks, Sherri |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I create a custom fill series for dates? | Excel Discussion (Misc queries) | |||
Identifying unique dates in a range of cells containing dates... | Excel Discussion (Misc queries) | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
US dates to UK?? | Excel Worksheet Functions | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) |