Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have basic knowledge of excel so please bear with me.
I am setting up a tracking spreadsheet. Three of the columns are date sent, due date and date received. I need the due date to automatically be inserted as 5 working days after the date sent. I don't know the formula to do this. Also, I have the following formula in the date received colomn =IF(J4<TODAY(),"OVERDUE","CURRENT") but don't want anything to be displayed if there is nothing in J4. At the moment, the blank cells that haven't been used yet already have the word CURRENT in that column and this is confusing. Any help pn this is greatly appreciated. Thanks Nic |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pre-1900 dates | Excel Discussion (Misc queries) | |||
entering items on specific dates of year | Excel Discussion (Misc queries) | |||
Need to pull current dates from list w/many dates | Excel Discussion (Misc queries) | |||
conditional formatting overdue dates | Excel Discussion (Misc queries) | |||
conditional formatting overdue dates | Excel Discussion (Misc queries) |