|
|
#1
03-23-2023, 05:57 AM
|
|||
|
|||
Formula for added date
Dear Community,
I'm trying to work out a formula so that if an invoice issued in Jan with 30 days payment term, this amount is collectible in Feb, if 45 days payment term then collectible in Mar and so on. I tried if function, but it didn't seem to work. I might have formulated it incorrectly. I attached the excel sheet and what expect return is. Hope for some help please. Thanks, Haha 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| I want to search a Word document for *any text* that was added/edited after a certain date/time... | RRB | Word | 1 | 05-06-2021 03:53 PM |
| Can I sort all notes by date added? | rafikiphoto | OneNote | 0 | 02-24-2018 11:14 PM |
 Trying to create a formula for descriptions to be added if a code is entered
|
rthomas | Excel | 6 | 10-24-2016 06:39 AM |
| dropdown lists and date picker added to word doc. | greg__reynolds | Word | 3 | 05-19-2014 12:19 AM |
| Can OneNote sort text/ sentences (within single page) by date added/ inserted..? | semiotically | OneNote | 0 | 04-03-2014 05:49 PM |
Windows 8 
Office 2010 32bit
Threaded Mode